package com.example.qxfw.qxxx.mapper;

import com.baomidou.dynamic.datasource.annotation.DS;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.qxfw.common.entity.IssuerInfo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
@DS("service")
public interface IssuerInfoMapper extends BaseMapper<IssuerInfo> {

    @Select("select username from issuer_info where permission='1'")
    List<String> selectName();

    @Select("select username from issuer_info where permission='${permission}'")
    List<String> selectName1(String permission);

    @Select("select phone from issuer_info where username = #{userName} ")
    String selectPhone(String userName);
}
